IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'ComanyUpdateByID')
	BEGIN
		DROP  Procedure  ComanyUpdateByID
	END

GO

CREATE Procedure ComanyUpdateByID
(
	@ComapnyID int
	, @CompanyName varchar(30)
	, @URL varchar(500)
	, @Symbol varchar(8)
	, @Exchange varchar(20)
)
AS

UPDATE Companies
SET CompanyName = @CompanyName
	, URL = @URL
	, Symbol = @Symbol
	, Exchange = @Exchange
WHERE CompanyID = @CompanyID